﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="PatientNoteDataSet" targetNamespace="http://tempuri.org/PatientNoteDataSet.xsd" xmlns:mstns="http://tempuri.org/PatientNoteDataSet.xsd" xmlns="http://tempuri.org/PatientNoteDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="RISConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="RISConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.ViewLayer.Properties.Settings.GlobalReference.Default.RISConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientNote_TableAdapter" GeneratorDataComponentClassName="PatientNote_TableAdapter" Name="PatientNote_" UserDataComponentName="PatientNote_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        PatientNote_.OID_, PatientNote_.Version_, PatientNote_.PatientOID_, PatientNote_.CreationTime_, PatientNote_.AuthorOID_, PatientNote_.CategoryOID_, 
                         PatientNote_.Comment_, PatientNote_.ValidFrom_, PatientNote_.ValidUntil_, Staff_.GivenName_ + ' ' + Staff_.FamilyName_ AS AuthorFullName, NoteSeverityEnum_.Value_ AS SeverityValue
FROM            PatientNote_ INNER JOIN
                         Staff_ ON PatientNote_.AuthorOID_ = Staff_.OID_ INNER JOIN
                         PatientNoteCategory_ ON PatientNote_.CategoryOID_ = PatientNoteCategory_.OID_ INNER JOIN
                         NoteSeverityEnum_ ON PatientNoteCategory_.Severity_ = NoteSeverityEnum_.Code_
WHERE        (PatientNote_.PatientOID_ = @patientOID)
ORDER BY PatientNote_.CreationTime_ DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="patientOID" ColumnName="PatientOID_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@patientOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="PatientOID_" DataSetColumn="PatientOID_" />
              <Mapping SourceColumn="CreationTime_" DataSetColumn="CreationTime_" />
              <Mapping SourceColumn="AuthorOID_" DataSetColumn="AuthorOID_" />
              <Mapping SourceColumn="CategoryOID_" DataSetColumn="CategoryOID_" />
              <Mapping SourceColumn="Comment_" DataSetColumn="Comment_" />
              <Mapping SourceColumn="ValidFrom_" DataSetColumn="ValidFrom_" />
              <Mapping SourceColumn="ValidUntil_" DataSetColumn="ValidUntil_" />
              <Mapping SourceColumn="AuthorFullName" DataSetColumn="AuthorFullName" />
              <Mapping SourceColumn="SeverityValue" DataSetColumn="SeverityValue" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="DeleteQuery" Modifier="Public" Name="DeleteQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="DeleteQuery">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>DELETE FROM PatientNote_
WHERE        (OID_ = @noteOID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="noteOID" ColumnName="OID_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@noteOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
              </DbSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO PatientNote_
                         (OID_, Version_, PatientOID_, CreationTime_, AuthorOID_, CategoryOID_, Comment_)
VALUES        (NEWID(), 1,@patientOID,@creationTime,@authorOID,@categoryOID,@comment)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="patientOID" ColumnName="PatientOID_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@patientOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="PatientOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="creationTime" ColumnName="CreationTime_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@creationTime" Precision="0" ProviderType="DateTime" Scale="0" Size="8" SourceColumn="CreationTime_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="authorOID" ColumnName="AuthorOID_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@authorOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="AuthorOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="categoryOID" ColumnName="CategoryOID_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@categoryOID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="CategoryOID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="comment" ColumnName="Comment_" DataSourceName="RIS.dbo.PatientNote_" DataTypeServer="nvarchar(1024)" DbType="String" Direction="Input" ParameterName="@comment" Precision="0" ProviderType="NVarChar" Scale="0" Size="1024" SourceColumn="Comment_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PatientNoteCategory_TableAdapter" GeneratorDataComponentClassName="PatientNoteCategory_TableAdapter" Name="PatientNoteCategory_" UserDataComponentName="PatientNoteCategory_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.PatientNoteCategory_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        PatientNoteCategory_.OID_, PatientNoteCategory_.Version_, PatientNoteCategory_.Name_, PatientNoteCategory_.Description_, PatientNoteCategory_.Severity_, 
                         PatientNoteCategory_.Deactivated_, PatientNoteCategory_.Name_ + ': ' + PatientNoteCategory_.Description_ + ' - ' + NoteSeverityEnum_.Value_ AS FullCategory
FROM            PatientNoteCategory_ INNER JOIN
                         NoteSeverityEnum_ ON PatientNoteCategory_.Severity_ = NoteSeverityEnum_.Code_
ORDER BY  PatientNoteCategory_.Name_ ASC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OID_" DataSetColumn="OID_" />
              <Mapping SourceColumn="Version_" DataSetColumn="Version_" />
              <Mapping SourceColumn="Name_" DataSetColumn="Name_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="Severity_" DataSetColumn="Severity_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
              <Mapping SourceColumn="FullCategory" DataSetColumn="FullCategory" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO PatientNoteCategory_
                         (OID_, Version_, Name_, Description_, Severity_, Deactivated_)
VALUES        (@oid, 1,@name,@description,@severityCode, 0)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="oid" ColumnName="OID_" DataSourceName="RIS.dbo.PatientNoteCategory_" DataTypeServer="uniqueidentifier" DbType="Guid" Direction="Input" ParameterName="@oid" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="16" SourceColumn="OID_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="name" ColumnName="Name_" DataSourceName="RIS.dbo.PatientNoteCategory_" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@name" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="Name_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="description" ColumnName="Description_" DataSourceName="RIS.dbo.PatientNoteCategory_" DataTypeServer="nvarchar(1024)" DbType="String" Direction="Input" ParameterName="@description" Precision="0" ProviderType="NVarChar" Scale="0" Size="1024" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="severityCode" ColumnName="Severity_" DataSourceName="RIS.dbo.PatientNoteCategory_" DataTypeServer="nvarchar(255)" DbType="String" Direction="Input" ParameterName="@severityCode" Precision="0" ProviderType="NVarChar" Scale="0" Size="255" SourceColumn="Severity_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NoteSeverityEnum_TableAdapter" GeneratorDataComponentClassName="NoteSeverityEnum_TableAdapter" Name="NoteSeverityEnum_" UserDataComponentName="NoteSeverityEnum_TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="RISConnectionString (Settings)" DbObjectName="RIS.dbo.NoteSeverityEnum_" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[NoteSeverityEnum_] WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[NoteSeverityEnum_] ([Code_], [Value_], [Description_], [DisplayOrder_], [Deactivated_]) VALUES (@Code_, @Value_, @Description_, @DisplayOrder_, @Deactivated_);
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM NoteSeverityEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM dbo.NoteSeverityEnum_</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[NoteSeverityEnum_] SET [Code_] = @Code_, [Value_] = @Value_, [Description_] = @Description_, [DisplayOrder_] = @DisplayOrder_, [Deactivated_] = @Deactivated_ WHERE (([Code_] = @Original_Code_) AND ((@IsNull_Value_ = 1 AND [Value_] IS NULL) OR ([Value_] = @Original_Value_)) AND ((@IsNull_Description_ = 1 AND [Description_] IS NULL) OR ([Description_] = @Original_Description_)) AND ((@IsNull_DisplayOrder_ = 1 AND [DisplayOrder_] IS NULL) OR ([DisplayOrder_] = @Original_DisplayOrder_)) AND ([Deactivated_] = @Original_Deactivated_));
SELECT Code_, Value_, Description_, DisplayOrder_, Deactivated_ FROM NoteSeverityEnum_ WHERE (Code_ = @Code_)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Code_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Code_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Value_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Value_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Value_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description_" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DisplayOrder_" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Single" Direction="Input" ParameterName="@Original_DisplayOrder_" Precision="0" ProviderType="Real" Scale="0" Size="0" SourceColumn="DisplayOrder_" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Deactivated_" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Deactivated_" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Code_" DataSetColumn="Code_" />
              <Mapping SourceColumn="Value_" DataSetColumn="Value_" />
              <Mapping SourceColumn="Description_" DataSetColumn="Description_" />
              <Mapping SourceColumn="DisplayOrder_" DataSetColumn="DisplayOrder_" />
              <Mapping SourceColumn="Deactivated_" DataSetColumn="Deactivated_" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="PatientNoteDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="PatientNoteDataSet" msprop:Generator_UserDSName="PatientNoteDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="PatientNote_" msprop:Generator_TableClassName="PatientNote_DataTable" msprop:Generator_TableVarName="tablePatientNote_" msprop:Generator_TablePropName="PatientNote_" msprop:Generator_RowDeletingName="PatientNote_RowDeleting" msprop:Generator_UserTableName="PatientNote_" msprop:Generator_RowChangingName="PatientNote_RowChanging" msprop:Generator_RowEvHandlerName="PatientNote_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientNote_RowDeleted" msprop:Generator_RowEvArgName="PatientNote_RowChangeEvent" msprop:Generator_RowChangedName="PatientNote_RowChanged" msprop:Generator_RowClassName="PatientNote_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="PatientOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPatientOID_" msprop:Generator_ColumnPropNameInRow="PatientOID_" msprop:Generator_ColumnPropNameInTable="PatientOID_Column" msprop:Generator_UserColumnName="PatientOID_" type="xs:string" />
              <xs:element name="CreationTime_" msprop:Generator_ColumnVarNameInTable="columnCreationTime_" msprop:Generator_ColumnPropNameInRow="CreationTime_" msprop:Generator_ColumnPropNameInTable="CreationTime_Column" msprop:Generator_UserColumnName="CreationTime_" type="xs:dateTime" />
              <xs:element name="AuthorOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnAuthorOID_" msprop:Generator_ColumnPropNameInRow="AuthorOID_" msprop:Generator_ColumnPropNameInTable="AuthorOID_Column" msprop:Generator_UserColumnName="AuthorOID_" type="xs:string" />
              <xs:element name="CategoryOID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCategoryOID_" msprop:Generator_ColumnPropNameInRow="CategoryOID_" msprop:Generator_ColumnPropNameInTable="CategoryOID_Column" msprop:Generator_UserColumnName="CategoryOID_" type="xs:string" />
              <xs:element name="Comment_" msprop:Generator_ColumnVarNameInTable="columnComment_" msprop:Generator_ColumnPropNameInRow="Comment_" msprop:Generator_ColumnPropNameInTable="Comment_Column" msprop:Generator_UserColumnName="Comment_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValidFrom_" msprop:Generator_ColumnVarNameInTable="columnValidFrom_" msprop:Generator_ColumnPropNameInRow="ValidFrom_" msprop:Generator_ColumnPropNameInTable="ValidFrom_Column" msprop:Generator_UserColumnName="ValidFrom_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ValidUntil_" msprop:Generator_ColumnVarNameInTable="columnValidUntil_" msprop:Generator_ColumnPropNameInRow="ValidUntil_" msprop:Generator_ColumnPropNameInTable="ValidUntil_Column" msprop:Generator_UserColumnName="ValidUntil_" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AuthorFullName" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnAuthorFullName" msprop:Generator_ColumnPropNameInRow="AuthorFullName" msprop:Generator_ColumnPropNameInTable="AuthorFullNameColumn" msprop:Generator_UserColumnName="AuthorFullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="81" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SeverityValue" msprop:Generator_ColumnVarNameInTable="columnSeverityValue" msprop:Generator_ColumnPropNameInRow="SeverityValue" msprop:Generator_ColumnPropNameInTable="SeverityValueColumn" msprop:Generator_UserColumnName="SeverityValue" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PatientNoteCategory_" msprop:Generator_TableClassName="PatientNoteCategory_DataTable" msprop:Generator_TableVarName="tablePatientNoteCategory_" msprop:Generator_TablePropName="PatientNoteCategory_" msprop:Generator_RowDeletingName="PatientNoteCategory_RowDeleting" msprop:Generator_UserTableName="PatientNoteCategory_" msprop:Generator_RowChangingName="PatientNoteCategory_RowChanging" msprop:Generator_RowEvHandlerName="PatientNoteCategory_RowChangeEventHandler" msprop:Generator_RowDeletedName="PatientNoteCategory_RowDeleted" msprop:Generator_RowEvArgName="PatientNoteCategory_RowChangeEvent" msprop:Generator_RowChangedName="PatientNoteCategory_RowChanged" msprop:Generator_RowClassName="PatientNoteCategory_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OID_" msdata:DataType="System.Guid, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOID_" msprop:Generator_ColumnPropNameInRow="OID_" msprop:Generator_ColumnPropNameInTable="OID_Column" msprop:Generator_UserColumnName="OID_" type="xs:string" />
              <xs:element name="Version_" msprop:Generator_ColumnVarNameInTable="columnVersion_" msprop:Generator_ColumnPropNameInRow="Version_" msprop:Generator_ColumnPropNameInTable="Version_Column" msprop:Generator_UserColumnName="Version_" type="xs:int" />
              <xs:element name="Name_" msprop:Generator_ColumnVarNameInTable="columnName_" msprop:Generator_ColumnPropNameInRow="Name_" msprop:Generator_ColumnPropNameInTable="Name_Column" msprop:Generator_UserColumnName="Name_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1024" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Severity_" msprop:Generator_ColumnVarNameInTable="columnSeverity_" msprop:Generator_ColumnPropNameInRow="Severity_" msprop:Generator_ColumnPropNameInTable="Severity_Column" msprop:Generator_UserColumnName="Severity_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
              <xs:element name="FullCategory" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnFullCategory" msprop:Generator_ColumnPropNameInRow="FullCategory" msprop:Generator_ColumnPropNameInTable="FullCategoryColumn" msprop:Generator_UserColumnName="FullCategory" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1334" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="NoteSeverityEnum_" msprop:Generator_TableClassName="NoteSeverityEnum_DataTable" msprop:Generator_TableVarName="tableNoteSeverityEnum_" msprop:Generator_TablePropName="NoteSeverityEnum_" msprop:Generator_RowDeletingName="NoteSeverityEnum_RowDeleting" msprop:Generator_UserTableName="NoteSeverityEnum_" msprop:Generator_RowChangingName="NoteSeverityEnum_RowChanging" msprop:Generator_RowEvHandlerName="NoteSeverityEnum_RowChangeEventHandler" msprop:Generator_RowDeletedName="NoteSeverityEnum_RowDeleted" msprop:Generator_RowEvArgName="NoteSeverityEnum_RowChangeEvent" msprop:Generator_RowChangedName="NoteSeverityEnum_RowChanged" msprop:Generator_RowClassName="NoteSeverityEnum_Row">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Code_" msprop:Generator_ColumnVarNameInTable="columnCode_" msprop:Generator_ColumnPropNameInRow="Code_" msprop:Generator_ColumnPropNameInTable="Code_Column" msprop:Generator_UserColumnName="Code_">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Value_" msprop:Generator_ColumnVarNameInTable="columnValue_" msprop:Generator_ColumnPropNameInRow="Value_" msprop:Generator_ColumnPropNameInTable="Value_Column" msprop:Generator_UserColumnName="Value_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description_" msprop:Generator_ColumnVarNameInTable="columnDescription_" msprop:Generator_ColumnPropNameInRow="Description_" msprop:Generator_ColumnPropNameInTable="Description_Column" msprop:Generator_UserColumnName="Description_" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DisplayOrder_" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder_" msprop:Generator_ColumnPropNameInRow="DisplayOrder_" msprop:Generator_ColumnPropNameInTable="DisplayOrder_Column" msprop:Generator_UserColumnName="DisplayOrder_" type="xs:float" minOccurs="0" />
              <xs:element name="Deactivated_" msprop:Generator_ColumnVarNameInTable="columnDeactivated_" msprop:Generator_ColumnPropNameInRow="Deactivated_" msprop:Generator_ColumnPropNameInTable="Deactivated_Column" msprop:Generator_UserColumnName="Deactivated_" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientNote_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="PatientNoteCategory__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PatientNoteCategory_" />
      <xs:field xpath="mstns:OID_" />
    </xs:unique>
    <xs:unique name="NoteSeverityEnum__Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:NoteSeverityEnum_" />
      <xs:field xpath="mstns:Code_" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_CategoryOID_E06728DC8E6EA3BAE9AB9147546F4CC9" msdata:parent="PatientNoteCategory_" msdata:child="PatientNote_" msdata:parentkey="OID_" msdata:childkey="CategoryOID_" msprop:Generator_UserChildTable="PatientNote_" msprop:Generator_ChildPropName="GetPatientNote_Rows" msprop:Generator_ParentPropName="PatientNoteCategory_Row" msprop:Generator_UserRelationName="FK_CategoryOID_E06728DC8E6EA3BAE9AB9147546F4CC9" msprop:Generator_RelationVarName="relationFK_CategoryOID_E06728DC8E6EA3BAE9AB9147546F4CC9" msprop:Generator_UserParentTable="PatientNoteCategory_" />
      <msdata:Relationship name="FK_Severity_5B980102A04B8556616F945875ECD773" msdata:parent="NoteSeverityEnum_" msdata:child="PatientNoteCategory_" msdata:parentkey="Code_" msdata:childkey="Severity_" msprop:Generator_UserChildTable="PatientNoteCategory_" msprop:Generator_ChildPropName="GetPatientNoteCategory_Rows" msprop:Generator_UserParentTable="NoteSeverityEnum_" msprop:Generator_UserRelationName="FK_Severity_5B980102A04B8556616F945875ECD773" msprop:Generator_RelationVarName="relationFK_Severity_5B980102A04B8556616F945875ECD773" msprop:Generator_ParentPropName="NoteSeverityEnum_Row" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>